select distinct substring(name,1,1) from stamps ,color_master where color_master.color_code=stamps.color_code and color_master.color='Red Purple and Buff' and year(stamps.issue_date)=1977 and stamps.serial_no='0847' order by substring(name,1,1)
StampsIndia
Color >> Red Purple and Buff >> Issue Date >> year >> 1977 >> Serial Number >> 0847 >> Alpha >> F >>